UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QScW1uYaQIXHP3KbEfh7aJewOpzYnvhN1sNrthZm9k0='
WHERE
key_id = '2ef979fefa4c87c3b09e7a309f8671a742f687ed43c583ba972144288042c132'
AND (
token = 'QScW1uYaQIXHP3KbEfh7aJewOpzYnvhN1sNrthZm9k0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)