UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YM7jwB5lz8/K0jp3jSX8srATEGpNjvhYG8faafhZM4w='
WHERE
key_id = 'd0addd148ed44de895ee08bcd89d2c21e4782c3b91578443977ac028645061e8'
AND (
token = 'YM7jwB5lz8/K0jp3jSX8srATEGpNjvhYG8faafhZM4w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)