UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '1lBwa0Z4vwMj10yuc8ibkKFaVu6EO28kbh50DIgqxGY=' 
WHERE 
  key_id = 'a779a8b59a5b2fdd9eabcf7f1d25fce8f6d5443878fbddf807ce990e69a2d408' 
  AND (
    token = '1lBwa0Z4vwMj10yuc8ibkKFaVu6EO28kbh50DIgqxGY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00040