UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'T6k7ecdagpbe1PvwcJI8K4Ddow+axQrCC4sgihwpyTU='
WHERE
key_id = 'f0560e45f686fe8f85c5a3d6c202e8536bc25fde6e7569d190cfd631a4eb3766'
AND (
token = 'T6k7ecdagpbe1PvwcJI8K4Ddow+axQrCC4sgihwpyTU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)