UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'mT9UUmsMZ2qFA9vm9Q6sR4BPRe7tTvTJZ8clTh6VvX0=' 
WHERE 
  key_id = '98304fa2820d5555cb63f99cf1053b9f6b4d62f789429311f109fa50ff84e38e' 
  AND (
    token = 'mT9UUmsMZ2qFA9vm9Q6sR4BPRe7tTvTJZ8clTh6VvX0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022