UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'etOtXNeI0G27mS98DWnGFZhKlsl34Poq6AVx8yWs45g='
WHERE
key_id = '40ac0c192fe34bfc985bb1b80ab0c6dc55744339cc90e9f136ddf66ab38ec291'
AND (
token = 'etOtXNeI0G27mS98DWnGFZhKlsl34Poq6AVx8yWs45g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)