UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/bV9hE/dkYGehKuYRdwvNAzV5QbA4VkHc9cAACBKp18='
WHERE
key_id = '47af43bce0ae3b270dd851921985d91615484a12e1ea2c65ae65ecedab9021e9'
AND (
token = '/bV9hE/dkYGehKuYRdwvNAzV5QbA4VkHc9cAACBKp18='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)