UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KVbMXw/CK7XpOKi/HiogG5dwdfbG7oqcVuc6F2hIvg8='
WHERE
key_id = 'bc3d191b01b40c9eb834840f5ee59452bc83079adac0e08f0477a6cc5c2a4859'
AND (
token = 'KVbMXw/CK7XpOKi/HiogG5dwdfbG7oqcVuc6F2hIvg8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)