UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XaAFtfHp7xX1K9o3R4N7zUM0YbsJecuEcZp6sAjNLE8='
WHERE
key_id = '6ee87670af0fdc4900bb960c24433903b93deb7473b45ecc54776e869b4a208d'
AND (
token = 'XaAFtfHp7xX1K9o3R4N7zUM0YbsJecuEcZp6sAjNLE8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)