UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CpAkjIpy1pUqDZocVdNc07AEJ0Wlzqa48tq0s0IkQys='
WHERE
key_id = 'fd7832e7e388cbe3de21e37b49fbca5f22dd3032f93e52a74968ddccc9164ed7'
AND (
token = 'CpAkjIpy1pUqDZocVdNc07AEJ0Wlzqa48tq0s0IkQys='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)