UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XD+o8Uky39INWSVX38djlsG0zSMOiXKynsPpzGAtN6A='
WHERE
key_id = '04c18ee13bd8fa707cff59ad5065fc8765cc14a9ddf972d7801a159f123e49c4'
AND (
token = 'XD+o8Uky39INWSVX38djlsG0zSMOiXKynsPpzGAtN6A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)