UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TlcjZL0vCo2B+SC1t5eV7pgT6qZ6i6PYILdBH5rTWQY='
WHERE
key_id = 'b8161463d055f0411d5cb57be51d1ac0853dd4ddb568a4489874b7700e30da42'
AND (
token = 'TlcjZL0vCo2B+SC1t5eV7pgT6qZ6i6PYILdBH5rTWQY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)