UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iiMhKrjyq6X6tsX7AB2NGicpdr/5mCsWDpMNdZzrzT8='
WHERE
key_id = 'df9919d071aaa25637262656bf0b043b1d399c8cfdd95c3f0d6eb19a8bc560c8'
AND (
token = 'iiMhKrjyq6X6tsX7AB2NGicpdr/5mCsWDpMNdZzrzT8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)