UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rxCkf1Bsh43sW0X9UFDHTnyK/Btam2ApPvODqELs/As='
WHERE
key_id = '0d7197d8d93b33194fc880cb23467bd92d31d344157dcb917f63220fd8d22caf'
AND (
token = 'rxCkf1Bsh43sW0X9UFDHTnyK/Btam2ApPvODqELs/As='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)