UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'we1t8og7a4A+hNvLZBXxD+JcKU1lOkC7kWG4pqoWA3Q='
WHERE
key_id = 'ea00b82c9bfa68553418e06a974324304ce357e768923a01efae4b37b8145851'
AND (
token = 'we1t8og7a4A+hNvLZBXxD+JcKU1lOkC7kWG4pqoWA3Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)