UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Oyd9BKWDQGb7WFjvT1mH8LfGwMN9Xrc0DO/PmtU9LTw=' 
WHERE 
  key_id = '71785a0fd20f7be674e80be8999ecc5e9834ab6c70c06414402b0e0714eb4914' 
  AND (
    token = 'Oyd9BKWDQGb7WFjvT1mH8LfGwMN9Xrc0DO/PmtU9LTw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028