UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HAP2J6/gB+sQOF41EQgeoRCILnNeqecfLmIqjbGsmis='
WHERE
key_id = 'd26ce0af3cc695eaf070ce7b1166408f3ebd1b894466e09342ea13f4bee04106'
AND (
token = 'HAP2J6/gB+sQOF41EQgeoRCILnNeqecfLmIqjbGsmis='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)