UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'y25bW/zFLFNW0k24Y5SDQIMeQqJhITCiyd595Yr81y8='
WHERE
key_id = 'dab742f351afa83ac77ac5582bd80dba0bb47b48b423e04583e76156f2267403'
AND (
token = 'y25bW/zFLFNW0k24Y5SDQIMeQqJhITCiyd595Yr81y8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)