UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KoULL4sFXFTugcTDRRSAcCiA7HtaVUHHuW1qVkm0WUA='
WHERE
key_id = '05208c1987786c9b336fa74fbfaefa7397cb0b021f6fe8a7e76e3e3c0cd0770a'
AND (
token = 'KoULL4sFXFTugcTDRRSAcCiA7HtaVUHHuW1qVkm0WUA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)