UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XTZ8+Qyj5YeYkJRXe4ocSV8wHfi/PdF9qOV8afPt01Y='
WHERE
key_id = '508640e952a423d69372f2fc320fa3f35ee054f31c4f1a10a680e3019160e7d2'
AND (
token = 'XTZ8+Qyj5YeYkJRXe4ocSV8wHfi/PdF9qOV8afPt01Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)