UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '2b6/HkvTB3l8Dr142kVabbJQi6NapPafe+3J8sH1QFE=' 
WHERE 
  key_id = '05754102fe7ed559e922a089d604cbe82b7f95d2063dae92aee9b69433a651e4' 
  AND (
    token = '2b6/HkvTB3l8Dr142kVabbJQi6NapPafe+3J8sH1QFE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00042