UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9s0E4YJe2eXeQvoLrWE9C7RhfgeKH80itdDbwYxF268='
WHERE
key_id = '3482dc73770f5561b210ae52b8a47203834580e273ee807e4edebe5f176a3e59'
AND (
token = '9s0E4YJe2eXeQvoLrWE9C7RhfgeKH80itdDbwYxF268='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)