UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9wLaK6jXCIXw7B1AUj8MdsxlVzMKmRL+o7nSiI92cfw='
WHERE
key_id = '2a430812a8037507aa0a398235a3bc248372715e67e78f3e87a072e18233328e'
AND (
token = '9wLaK6jXCIXw7B1AUj8MdsxlVzMKmRL+o7nSiI92cfw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)