UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vCqfKIWr87rZZ1jBqgGqWhadt38sXJVsaz/4ImG2kvE='
WHERE
key_id = 'e9265cdf823a33c9ae9a4fa188956e429f3c57f30e1af50f03418a92acfa92f7'
AND (
token = 'vCqfKIWr87rZZ1jBqgGqWhadt38sXJVsaz/4ImG2kvE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)