UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SEMLi64aNBzSKJISmBYglPnp6O1XRcGO2kpUn0KEcwg='
WHERE
key_id = '1daf3e6ac3478bf4553771c9c6329d827fc676d61e59805c4fe9f524897125af'
AND (
token = 'SEMLi64aNBzSKJISmBYglPnp6O1XRcGO2kpUn0KEcwg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)