UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zPWQ3rMwaXtwotlw/kOOrYFRUQgqxq0FW19TuAwz0cE='
WHERE
key_id = 'b0af9600ba8c839180521a71f2cc8be917a0d2b8a0209efaad18810978671344'
AND (
token = 'zPWQ3rMwaXtwotlw/kOOrYFRUQgqxq0FW19TuAwz0cE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)