UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LaLLj1bZilEmPAAmE0An03WqYJeoPLwF8Hgi2IQRLEY='
WHERE
key_id = 'be0252c25589cdb586f1ce33c7a539e172dfbd187f28ebb1950a3f8a90ba6c5e'
AND (
token = 'LaLLj1bZilEmPAAmE0An03WqYJeoPLwF8Hgi2IQRLEY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)