UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qszXaW/LKI/SsvNzTiciIvxP9fFL293gS/nwx4EwmOE='
WHERE
key_id = '2d4c64d6db8af94b28e1ffd127acaa759cde38632976992c9ca90f2fd5a4e99e'
AND (
token = 'qszXaW/LKI/SsvNzTiciIvxP9fFL293gS/nwx4EwmOE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)