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