UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oLXlJdmB5CcJtxa2AJd59En/vC0cGmclGISP3heZnpY='
WHERE
key_id = 'd3cca948d70f3e3d5fb17b762f28b1ccd832f064d38d4d8dac2c5f79ab79fc65'
AND (
token = 'oLXlJdmB5CcJtxa2AJd59En/vC0cGmclGISP3heZnpY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)