UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GLHr7VevrxmoIFtcLp30sc0h9/a5YK/Du2OTwjpmPtA='
WHERE
key_id = '87f7c0ff1eb84e02de6a44b2ec6f60bf8eb823bccdcd300fb94e03a73dee0d6a'
AND (
token = 'GLHr7VevrxmoIFtcLp30sc0h9/a5YK/Du2OTwjpmPtA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)