UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yM4GjDkOS+BvdWOr4EWLetpCOi8WHKBvTF8j2P4B6vg='
WHERE
key_id = '9bc3eb46ec4a883d1a9ab968a920c30f0bb13203139cce196b9567a779a98526'
AND (
token = 'yM4GjDkOS+BvdWOr4EWLetpCOi8WHKBvTF8j2P4B6vg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)