UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eMR5qGJWj3rxOaJWhT9dg0KLaPagNSCnLYlfAIGPQG4='
WHERE
key_id = '9c350332f9b2c81d94d898096c55b59a433ada765c514afc92e867b4322bf0cb'
AND (
token = 'eMR5qGJWj3rxOaJWhT9dg0KLaPagNSCnLYlfAIGPQG4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)