UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zpkx0AkEFoEgasau6JwzwN3L66YZcyRAvnHHUjVn08U='
WHERE
key_id = '3f5002067864d9f2108e6a962b30f11c388f187f89fc0f4556ad052a0ae74a17'
AND (
token = 'Zpkx0AkEFoEgasau6JwzwN3L66YZcyRAvnHHUjVn08U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)