UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4+w2we3J4+r8sVIBetn1Soz2cSXtMvvYyIcnjapiCDs='
WHERE
key_id = '103c37b61e1e759712bb841c09e499202c9dd999de8a1db6563326b0ec6542ee'
AND (
token = '4+w2we3J4+r8sVIBetn1Soz2cSXtMvvYyIcnjapiCDs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)