UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vZTjSW7XUJjCW8uD2UnMl6FPdh3ufsvYLc5AX0KyPrk='
WHERE
key_id = '63d77fb95f800b53344b07be7ca1c49427f87041c388e55bf11f5239bbc30bc0'
AND (
token = 'vZTjSW7XUJjCW8uD2UnMl6FPdh3ufsvYLc5AX0KyPrk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)