UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'y4LTEt/N6ngdQWH+Q9YwK6WAvCvq9mQVu31+IjwEj24=' 
WHERE 
  key_id = '0bb3436338b8560713480e7767fe4777f4056b064e29e23373066094559487c3' 
  AND (
    token = 'y4LTEt/N6ngdQWH+Q9YwK6WAvCvq9mQVu31+IjwEj24=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033